<%@ page language="java" import="java.util.*,com.entity.*" pageEncoding="UTF-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<%@ taglib uri="http://jsptags.com/tags/navigation/pager" prefix="pg" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/functions"  prefix="fn"%>
<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %> 
<%@page contentType="application/vnd.ms-excel; charset=UTF-8"%> 
<%    
//response.setContentType("application/xls");    
//response.setHeader("Content-Disposition", "inline; filename=\"test.xls\"");    
%> 
<html xmlns=" http://www.w3.org/1999/xhtml">
  <head>人员信息表 
  <meta Content-Disposition="attachment; filename=人员资料.xls" />
  </head>
   <body>

<table style='mso-number-format:".0";' width="2000" id="table1" border="0" cellpadding="0" cellspacing="0" class="sortable TableBlock no-top-border">

  <tr class="title_text">
    <td align="center"  onclick="this.blur(); return sortTable('offTblBdy',  1, true);">编号</td>
    <td align="center"  onclick="this.blur(); return sortTable('offTblBdy',  2, true);">姓名</td>
    <td align="center" >性别</td>
    <td align="center" >出生日期</td>
    <td align="center" >参加工作日期</td>
    <td align="center" >参加计生工作日期</td>
    <td align="center" >婚姻状况</td>
    <td align="center" >政治面貌</td>
    <td align="center" >民族</td>
    <td align="center" >籍贯</td>
    <td align="center" >学历</td>
    <td align="center" >专业</td>
    <td align="center" >毕业院校</td>
    <td align="center" >联系地址</td>
    <td align="center" >离职时间</td>
    <td align="center" >身份证号</td>
    <td align="center" >联系电话</td>
    <td align="center" >基本工资</td>
    <td align="center" >部门</td>
    <td align="center" >职务</td>
    <td align="center" >职称</td>
    <td align="center" >人员属性</td>
    <td align="center" >合同期限</td>
    <td align="center" >个人简历</td>
    <td align="center" >备注</td>
  </tr>
  <c:forEach var="l" items="${list}">
  <tr>
    <td align="center" >${l.bh}</td>
    <td align="center" >${l.xm}</td>
    <td align="center" >${l.xb}</td>
    <td align="center" >${l.csrqString} </td>
    <td align="center" >${l.cjgzrqString}</td>
    <td align="center" >${l.cjjsgzrqString}</td>
    <td align="center" >${l.hyzk}</td>
    <td align="center" >${l.zzmm}</td>
    <td align="center" >${l.mz}</td>
    <td align="center" >${l.jg}</td>
    <td align="center" >${l.xl}</td>
    <td align="center" >${l.zy}</td>
    <td align="center" >${l.byyx}</td>
    <td align="center" >${l.lxdz}</td>
    <td align="center" >${l.lzsjString}</td>
    <td align="center" class="txt" >'${l.sfzh}' </td>
    <td align="center" >${l.lxdh}</td>
    <td align="center" >${l.jbgz}</td>
    <td align="center" >${l.zdByBmbh.zdqc}</td>
    <td align="center" >${l.zdByZwbh.typename}</td>
    <td align="center" >${l.zdByZcbh.typename}</td>
    <td align="center" >${l.rysx}</td>
    <td align="center" >${l.htqxString}至${l.htqx2String}</td>
    <td align="center" >${l.grjl}</td>
    <td align="center" >${l.bz}</td>
    
  </tr>
  </c:forEach>
</table>
 <style type="text/css"> 
<!-- 
td { 
background-color: #FFFFFF; 
} 
.txt 
{padding-top:1px; 
padding-right:1px; 
padding-left:1px; 
mso-ignore:padding; 
color:black; 
font-size:11.0pt; 
font-weight:400; 
font-style:normal; 
text-decoration:none; 
font-family:宋体; 
mso-generic-font-family:auto; 
mso-font-charset:134; 
mso-number-format:".0";// //关键是这里 
text-align:general; 
vertical-align:middle; 
mso-background-source:auto; 
mso-pattern:auto; 
white-space:nowrap;} 
--> 
</style> 
  </body>
</html>